package com.wn.purchaeReturn.entity;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class PurPurchasereturnExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    private Integer limit;

    private Long offset;

    public PurPurchasereturnExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public void setLimit(Integer limit) {
        this.limit = limit;
    }

    public Integer getLimit() {
        return limit;
    }

    public void setOffset(Long offset) {
        this.offset = offset;
    }

    public Long getOffset() {
        return offset;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        public Criteria andPurchasertnnoIsNull() {
            addCriterion("PurchaseRtnNo is null");
            return (Criteria) this;
        }

        public Criteria andPurchasertnnoIsNotNull() {
            addCriterion("PurchaseRtnNo is not null");
            return (Criteria) this;
        }

        public Criteria andPurchasertnnoEqualTo(String value) {
            addCriterion("PurchaseRtnNo =", value, "purchasertnno");
            return (Criteria) this;
        }

        public Criteria andPurchasertnnoNotEqualTo(String value) {
            addCriterion("PurchaseRtnNo <>", value, "purchasertnno");
            return (Criteria) this;
        }

        public Criteria andPurchasertnnoGreaterThan(String value) {
            addCriterion("PurchaseRtnNo >", value, "purchasertnno");
            return (Criteria) this;
        }

        public Criteria andPurchasertnnoGreaterThanOrEqualTo(String value) {
            addCriterion("PurchaseRtnNo >=", value, "purchasertnno");
            return (Criteria) this;
        }

        public Criteria andPurchasertnnoLessThan(String value) {
            addCriterion("PurchaseRtnNo <", value, "purchasertnno");
            return (Criteria) this;
        }

        public Criteria andPurchasertnnoLessThanOrEqualTo(String value) {
            addCriterion("PurchaseRtnNo <=", value, "purchasertnno");
            return (Criteria) this;
        }

        public Criteria andPurchasertnnoLike(String value) {
            addCriterion("PurchaseRtnNo like", value, "purchasertnno");
            return (Criteria) this;
        }

        public Criteria andPurchasertnnoNotLike(String value) {
            addCriterion("PurchaseRtnNo not like", value, "purchasertnno");
            return (Criteria) this;
        }

        public Criteria andPurchasertnnoIn(List<String> values) {
            addCriterion("PurchaseRtnNo in", values, "purchasertnno");
            return (Criteria) this;
        }

        public Criteria andPurchasertnnoNotIn(List<String> values) {
            addCriterion("PurchaseRtnNo not in", values, "purchasertnno");
            return (Criteria) this;
        }

        public Criteria andPurchasertnnoBetween(String value1, String value2) {
            addCriterion("PurchaseRtnNo between", value1, value2, "purchasertnno");
            return (Criteria) this;
        }

        public Criteria andPurchasertnnoNotBetween(String value1, String value2) {
            addCriterion("PurchaseRtnNo not between", value1, value2, "purchasertnno");
            return (Criteria) this;
        }

        public Criteria andRtntypeIsNull() {
            addCriterion("RtnType is null");
            return (Criteria) this;
        }

        public Criteria andRtntypeIsNotNull() {
            addCriterion("RtnType is not null");
            return (Criteria) this;
        }

        public Criteria andRtntypeEqualTo(String value) {
            addCriterion("RtnType =", value, "rtntype");
            return (Criteria) this;
        }

        public Criteria andRtntypeNotEqualTo(String value) {
            addCriterion("RtnType <>", value, "rtntype");
            return (Criteria) this;
        }

        public Criteria andRtntypeGreaterThan(String value) {
            addCriterion("RtnType >", value, "rtntype");
            return (Criteria) this;
        }

        public Criteria andRtntypeGreaterThanOrEqualTo(String value) {
            addCriterion("RtnType >=", value, "rtntype");
            return (Criteria) this;
        }

        public Criteria andRtntypeLessThan(String value) {
            addCriterion("RtnType <", value, "rtntype");
            return (Criteria) this;
        }

        public Criteria andRtntypeLessThanOrEqualTo(String value) {
            addCriterion("RtnType <=", value, "rtntype");
            return (Criteria) this;
        }

        public Criteria andRtntypeLike(String value) {
            addCriterion("RtnType like", value, "rtntype");
            return (Criteria) this;
        }

        public Criteria andRtntypeNotLike(String value) {
            addCriterion("RtnType not like", value, "rtntype");
            return (Criteria) this;
        }

        public Criteria andRtntypeIn(List<String> values) {
            addCriterion("RtnType in", values, "rtntype");
            return (Criteria) this;
        }

        public Criteria andRtntypeNotIn(List<String> values) {
            addCriterion("RtnType not in", values, "rtntype");
            return (Criteria) this;
        }

        public Criteria andRtntypeBetween(String value1, String value2) {
            addCriterion("RtnType between", value1, value2, "rtntype");
            return (Criteria) this;
        }

        public Criteria andRtntypeNotBetween(String value1, String value2) {
            addCriterion("RtnType not between", value1, value2, "rtntype");
            return (Criteria) this;
        }

        public Criteria andPurchasenoIsNull() {
            addCriterion("PurchaseNo is null");
            return (Criteria) this;
        }

        public Criteria andPurchasenoIsNotNull() {
            addCriterion("PurchaseNo is not null");
            return (Criteria) this;
        }

        public Criteria andPurchasenoEqualTo(String value) {
            addCriterion("PurchaseNo =", value, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoNotEqualTo(String value) {
            addCriterion("PurchaseNo <>", value, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoGreaterThan(String value) {
            addCriterion("PurchaseNo >", value, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoGreaterThanOrEqualTo(String value) {
            addCriterion("PurchaseNo >=", value, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoLessThan(String value) {
            addCriterion("PurchaseNo <", value, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoLessThanOrEqualTo(String value) {
            addCriterion("PurchaseNo <=", value, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoLike(String value) {
            addCriterion("PurchaseNo like", value, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoNotLike(String value) {
            addCriterion("PurchaseNo not like", value, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoIn(List<String> values) {
            addCriterion("PurchaseNo in", values, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoNotIn(List<String> values) {
            addCriterion("PurchaseNo not in", values, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoBetween(String value1, String value2) {
            addCriterion("PurchaseNo between", value1, value2, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoNotBetween(String value1, String value2) {
            addCriterion("PurchaseNo not between", value1, value2, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasewayIsNull() {
            addCriterion("PurchaseWay is null");
            return (Criteria) this;
        }

        public Criteria andPurchasewayIsNotNull() {
            addCriterion("PurchaseWay is not null");
            return (Criteria) this;
        }

        public Criteria andPurchasewayEqualTo(String value) {
            addCriterion("PurchaseWay =", value, "purchaseway");
            return (Criteria) this;
        }

        public Criteria andPurchasewayNotEqualTo(String value) {
            addCriterion("PurchaseWay <>", value, "purchaseway");
            return (Criteria) this;
        }

        public Criteria andPurchasewayGreaterThan(String value) {
            addCriterion("PurchaseWay >", value, "purchaseway");
            return (Criteria) this;
        }

        public Criteria andPurchasewayGreaterThanOrEqualTo(String value) {
            addCriterion("PurchaseWay >=", value, "purchaseway");
            return (Criteria) this;
        }

        public Criteria andPurchasewayLessThan(String value) {
            addCriterion("PurchaseWay <", value, "purchaseway");
            return (Criteria) this;
        }

        public Criteria andPurchasewayLessThanOrEqualTo(String value) {
            addCriterion("PurchaseWay <=", value, "purchaseway");
            return (Criteria) this;
        }

        public Criteria andPurchasewayLike(String value) {
            addCriterion("PurchaseWay like", value, "purchaseway");
            return (Criteria) this;
        }

        public Criteria andPurchasewayNotLike(String value) {
            addCriterion("PurchaseWay not like", value, "purchaseway");
            return (Criteria) this;
        }

        public Criteria andPurchasewayIn(List<String> values) {
            addCriterion("PurchaseWay in", values, "purchaseway");
            return (Criteria) this;
        }

        public Criteria andPurchasewayNotIn(List<String> values) {
            addCriterion("PurchaseWay not in", values, "purchaseway");
            return (Criteria) this;
        }

        public Criteria andPurchasewayBetween(String value1, String value2) {
            addCriterion("PurchaseWay between", value1, value2, "purchaseway");
            return (Criteria) this;
        }

        public Criteria andPurchasewayNotBetween(String value1, String value2) {
            addCriterion("PurchaseWay not between", value1, value2, "purchaseway");
            return (Criteria) this;
        }

        public Criteria andSubunitcdIsNull() {
            addCriterion("SubunitCD is null");
            return (Criteria) this;
        }

        public Criteria andSubunitcdIsNotNull() {
            addCriterion("SubunitCD is not null");
            return (Criteria) this;
        }

        public Criteria andSubunitcdEqualTo(String value) {
            addCriterion("SubunitCD =", value, "subunitcd");
            return (Criteria) this;
        }

        public Criteria andSubunitcdNotEqualTo(String value) {
            addCriterion("SubunitCD <>", value, "subunitcd");
            return (Criteria) this;
        }

        public Criteria andSubunitcdGreaterThan(String value) {
            addCriterion("SubunitCD >", value, "subunitcd");
            return (Criteria) this;
        }

        public Criteria andSubunitcdGreaterThanOrEqualTo(String value) {
            addCriterion("SubunitCD >=", value, "subunitcd");
            return (Criteria) this;
        }

        public Criteria andSubunitcdLessThan(String value) {
            addCriterion("SubunitCD <", value, "subunitcd");
            return (Criteria) this;
        }

        public Criteria andSubunitcdLessThanOrEqualTo(String value) {
            addCriterion("SubunitCD <=", value, "subunitcd");
            return (Criteria) this;
        }

        public Criteria andSubunitcdLike(String value) {
            addCriterion("SubunitCD like", value, "subunitcd");
            return (Criteria) this;
        }

        public Criteria andSubunitcdNotLike(String value) {
            addCriterion("SubunitCD not like", value, "subunitcd");
            return (Criteria) this;
        }

        public Criteria andSubunitcdIn(List<String> values) {
            addCriterion("SubunitCD in", values, "subunitcd");
            return (Criteria) this;
        }

        public Criteria andSubunitcdNotIn(List<String> values) {
            addCriterion("SubunitCD not in", values, "subunitcd");
            return (Criteria) this;
        }

        public Criteria andSubunitcdBetween(String value1, String value2) {
            addCriterion("SubunitCD between", value1, value2, "subunitcd");
            return (Criteria) this;
        }

        public Criteria andSubunitcdNotBetween(String value1, String value2) {
            addCriterion("SubunitCD not between", value1, value2, "subunitcd");
            return (Criteria) this;
        }

        public Criteria andSupplycdIsNull() {
            addCriterion("SupplyCD is null");
            return (Criteria) this;
        }

        public Criteria andSupplycdIsNotNull() {
            addCriterion("SupplyCD is not null");
            return (Criteria) this;
        }

        public Criteria andSupplycdEqualTo(String value) {
            addCriterion("SupplyCD =", value, "supplycd");
            return (Criteria) this;
        }

        public Criteria andSupplycdNotEqualTo(String value) {
            addCriterion("SupplyCD <>", value, "supplycd");
            return (Criteria) this;
        }

        public Criteria andSupplycdGreaterThan(String value) {
            addCriterion("SupplyCD >", value, "supplycd");
            return (Criteria) this;
        }

        public Criteria andSupplycdGreaterThanOrEqualTo(String value) {
            addCriterion("SupplyCD >=", value, "supplycd");
            return (Criteria) this;
        }

        public Criteria andSupplycdLessThan(String value) {
            addCriterion("SupplyCD <", value, "supplycd");
            return (Criteria) this;
        }

        public Criteria andSupplycdLessThanOrEqualTo(String value) {
            addCriterion("SupplyCD <=", value, "supplycd");
            return (Criteria) this;
        }

        public Criteria andSupplycdLike(String value) {
            addCriterion("SupplyCD like", value, "supplycd");
            return (Criteria) this;
        }

        public Criteria andSupplycdNotLike(String value) {
            addCriterion("SupplyCD not like", value, "supplycd");
            return (Criteria) this;
        }

        public Criteria andSupplycdIn(List<String> values) {
            addCriterion("SupplyCD in", values, "supplycd");
            return (Criteria) this;
        }

        public Criteria andSupplycdNotIn(List<String> values) {
            addCriterion("SupplyCD not in", values, "supplycd");
            return (Criteria) this;
        }

        public Criteria andSupplycdBetween(String value1, String value2) {
            addCriterion("SupplyCD between", value1, value2, "supplycd");
            return (Criteria) this;
        }

        public Criteria andSupplycdNotBetween(String value1, String value2) {
            addCriterion("SupplyCD not between", value1, value2, "supplycd");
            return (Criteria) this;
        }

        public Criteria andTicketnoIsNull() {
            addCriterion("TicketNo is null");
            return (Criteria) this;
        }

        public Criteria andTicketnoIsNotNull() {
            addCriterion("TicketNo is not null");
            return (Criteria) this;
        }

        public Criteria andTicketnoEqualTo(String value) {
            addCriterion("TicketNo =", value, "ticketno");
            return (Criteria) this;
        }

        public Criteria andTicketnoNotEqualTo(String value) {
            addCriterion("TicketNo <>", value, "ticketno");
            return (Criteria) this;
        }

        public Criteria andTicketnoGreaterThan(String value) {
            addCriterion("TicketNo >", value, "ticketno");
            return (Criteria) this;
        }

        public Criteria andTicketnoGreaterThanOrEqualTo(String value) {
            addCriterion("TicketNo >=", value, "ticketno");
            return (Criteria) this;
        }

        public Criteria andTicketnoLessThan(String value) {
            addCriterion("TicketNo <", value, "ticketno");
            return (Criteria) this;
        }

        public Criteria andTicketnoLessThanOrEqualTo(String value) {
            addCriterion("TicketNo <=", value, "ticketno");
            return (Criteria) this;
        }

        public Criteria andTicketnoLike(String value) {
            addCriterion("TicketNo like", value, "ticketno");
            return (Criteria) this;
        }

        public Criteria andTicketnoNotLike(String value) {
            addCriterion("TicketNo not like", value, "ticketno");
            return (Criteria) this;
        }

        public Criteria andTicketnoIn(List<String> values) {
            addCriterion("TicketNo in", values, "ticketno");
            return (Criteria) this;
        }

        public Criteria andTicketnoNotIn(List<String> values) {
            addCriterion("TicketNo not in", values, "ticketno");
            return (Criteria) this;
        }

        public Criteria andTicketnoBetween(String value1, String value2) {
            addCriterion("TicketNo between", value1, value2, "ticketno");
            return (Criteria) this;
        }

        public Criteria andTicketnoNotBetween(String value1, String value2) {
            addCriterion("TicketNo not between", value1, value2, "ticketno");
            return (Criteria) this;
        }

        public Criteria andTicketymdIsNull() {
            addCriterion("TicketYMD is null");
            return (Criteria) this;
        }

        public Criteria andTicketymdIsNotNull() {
            addCriterion("TicketYMD is not null");
            return (Criteria) this;
        }

        public Criteria andTicketymdEqualTo(String value) {
            addCriterion("TicketYMD =", value, "ticketymd");
            return (Criteria) this;
        }

        public Criteria andTicketymdNotEqualTo(String value) {
            addCriterion("TicketYMD <>", value, "ticketymd");
            return (Criteria) this;
        }

        public Criteria andTicketymdGreaterThan(String value) {
            addCriterion("TicketYMD >", value, "ticketymd");
            return (Criteria) this;
        }

        public Criteria andTicketymdGreaterThanOrEqualTo(String value) {
            addCriterion("TicketYMD >=", value, "ticketymd");
            return (Criteria) this;
        }

        public Criteria andTicketymdLessThan(String value) {
            addCriterion("TicketYMD <", value, "ticketymd");
            return (Criteria) this;
        }

        public Criteria andTicketymdLessThanOrEqualTo(String value) {
            addCriterion("TicketYMD <=", value, "ticketymd");
            return (Criteria) this;
        }

        public Criteria andTicketymdLike(String value) {
            addCriterion("TicketYMD like", value, "ticketymd");
            return (Criteria) this;
        }

        public Criteria andTicketymdNotLike(String value) {
            addCriterion("TicketYMD not like", value, "ticketymd");
            return (Criteria) this;
        }

        public Criteria andTicketymdIn(List<String> values) {
            addCriterion("TicketYMD in", values, "ticketymd");
            return (Criteria) this;
        }

        public Criteria andTicketymdNotIn(List<String> values) {
            addCriterion("TicketYMD not in", values, "ticketymd");
            return (Criteria) this;
        }

        public Criteria andTicketymdBetween(String value1, String value2) {
            addCriterion("TicketYMD between", value1, value2, "ticketymd");
            return (Criteria) this;
        }

        public Criteria andTicketymdNotBetween(String value1, String value2) {
            addCriterion("TicketYMD not between", value1, value2, "ticketymd");
            return (Criteria) this;
        }

        public Criteria andTotalmnyIsNull() {
            addCriterion("TotalMny is null");
            return (Criteria) this;
        }

        public Criteria andTotalmnyIsNotNull() {
            addCriterion("TotalMny is not null");
            return (Criteria) this;
        }

        public Criteria andTotalmnyEqualTo(BigDecimal value) {
            addCriterion("TotalMny =", value, "totalmny");
            return (Criteria) this;
        }

        public Criteria andTotalmnyNotEqualTo(BigDecimal value) {
            addCriterion("TotalMny <>", value, "totalmny");
            return (Criteria) this;
        }

        public Criteria andTotalmnyGreaterThan(BigDecimal value) {
            addCriterion("TotalMny >", value, "totalmny");
            return (Criteria) this;
        }

        public Criteria andTotalmnyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("TotalMny >=", value, "totalmny");
            return (Criteria) this;
        }

        public Criteria andTotalmnyLessThan(BigDecimal value) {
            addCriterion("TotalMny <", value, "totalmny");
            return (Criteria) this;
        }

        public Criteria andTotalmnyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("TotalMny <=", value, "totalmny");
            return (Criteria) this;
        }

        public Criteria andTotalmnyIn(List<BigDecimal> values) {
            addCriterion("TotalMny in", values, "totalmny");
            return (Criteria) this;
        }

        public Criteria andTotalmnyNotIn(List<BigDecimal> values) {
            addCriterion("TotalMny not in", values, "totalmny");
            return (Criteria) this;
        }

        public Criteria andTotalmnyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TotalMny between", value1, value2, "totalmny");
            return (Criteria) this;
        }

        public Criteria andTotalmnyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TotalMny not between", value1, value2, "totalmny");
            return (Criteria) this;
        }

        public Criteria andDescdIsNull() {
            addCriterion("DesCD is null");
            return (Criteria) this;
        }

        public Criteria andDescdIsNotNull() {
            addCriterion("DesCD is not null");
            return (Criteria) this;
        }

        public Criteria andDescdEqualTo(String value) {
            addCriterion("DesCD =", value, "descd");
            return (Criteria) this;
        }

        public Criteria andDescdNotEqualTo(String value) {
            addCriterion("DesCD <>", value, "descd");
            return (Criteria) this;
        }

        public Criteria andDescdGreaterThan(String value) {
            addCriterion("DesCD >", value, "descd");
            return (Criteria) this;
        }

        public Criteria andDescdGreaterThanOrEqualTo(String value) {
            addCriterion("DesCD >=", value, "descd");
            return (Criteria) this;
        }

        public Criteria andDescdLessThan(String value) {
            addCriterion("DesCD <", value, "descd");
            return (Criteria) this;
        }

        public Criteria andDescdLessThanOrEqualTo(String value) {
            addCriterion("DesCD <=", value, "descd");
            return (Criteria) this;
        }

        public Criteria andDescdLike(String value) {
            addCriterion("DesCD like", value, "descd");
            return (Criteria) this;
        }

        public Criteria andDescdNotLike(String value) {
            addCriterion("DesCD not like", value, "descd");
            return (Criteria) this;
        }

        public Criteria andDescdIn(List<String> values) {
            addCriterion("DesCD in", values, "descd");
            return (Criteria) this;
        }

        public Criteria andDescdNotIn(List<String> values) {
            addCriterion("DesCD not in", values, "descd");
            return (Criteria) this;
        }

        public Criteria andDescdBetween(String value1, String value2) {
            addCriterion("DesCD between", value1, value2, "descd");
            return (Criteria) this;
        }

        public Criteria andDescdNotBetween(String value1, String value2) {
            addCriterion("DesCD not between", value1, value2, "descd");
            return (Criteria) this;
        }

        public Criteria andInstcflgIsNull() {
            addCriterion("InStcFLG is null");
            return (Criteria) this;
        }

        public Criteria andInstcflgIsNotNull() {
            addCriterion("InStcFLG is not null");
            return (Criteria) this;
        }

        public Criteria andInstcflgEqualTo(String value) {
            addCriterion("InStcFLG =", value, "instcflg");
            return (Criteria) this;
        }

        public Criteria andInstcflgNotEqualTo(String value) {
            addCriterion("InStcFLG <>", value, "instcflg");
            return (Criteria) this;
        }

        public Criteria andInstcflgGreaterThan(String value) {
            addCriterion("InStcFLG >", value, "instcflg");
            return (Criteria) this;
        }

        public Criteria andInstcflgGreaterThanOrEqualTo(String value) {
            addCriterion("InStcFLG >=", value, "instcflg");
            return (Criteria) this;
        }

        public Criteria andInstcflgLessThan(String value) {
            addCriterion("InStcFLG <", value, "instcflg");
            return (Criteria) this;
        }

        public Criteria andInstcflgLessThanOrEqualTo(String value) {
            addCriterion("InStcFLG <=", value, "instcflg");
            return (Criteria) this;
        }

        public Criteria andInstcflgLike(String value) {
            addCriterion("InStcFLG like", value, "instcflg");
            return (Criteria) this;
        }

        public Criteria andInstcflgNotLike(String value) {
            addCriterion("InStcFLG not like", value, "instcflg");
            return (Criteria) this;
        }

        public Criteria andInstcflgIn(List<String> values) {
            addCriterion("InStcFLG in", values, "instcflg");
            return (Criteria) this;
        }

        public Criteria andInstcflgNotIn(List<String> values) {
            addCriterion("InStcFLG not in", values, "instcflg");
            return (Criteria) this;
        }

        public Criteria andInstcflgBetween(String value1, String value2) {
            addCriterion("InStcFLG between", value1, value2, "instcflg");
            return (Criteria) this;
        }

        public Criteria andInstcflgNotBetween(String value1, String value2) {
            addCriterion("InStcFLG not between", value1, value2, "instcflg");
            return (Criteria) this;
        }

        public Criteria andPurchaseflgIsNull() {
            addCriterion("PurchaseFLG is null");
            return (Criteria) this;
        }

        public Criteria andPurchaseflgIsNotNull() {
            addCriterion("PurchaseFLG is not null");
            return (Criteria) this;
        }

        public Criteria andPurchaseflgEqualTo(String value) {
            addCriterion("PurchaseFLG =", value, "purchaseflg");
            return (Criteria) this;
        }

        public Criteria andPurchaseflgNotEqualTo(String value) {
            addCriterion("PurchaseFLG <>", value, "purchaseflg");
            return (Criteria) this;
        }

        public Criteria andPurchaseflgGreaterThan(String value) {
            addCriterion("PurchaseFLG >", value, "purchaseflg");
            return (Criteria) this;
        }

        public Criteria andPurchaseflgGreaterThanOrEqualTo(String value) {
            addCriterion("PurchaseFLG >=", value, "purchaseflg");
            return (Criteria) this;
        }

        public Criteria andPurchaseflgLessThan(String value) {
            addCriterion("PurchaseFLG <", value, "purchaseflg");
            return (Criteria) this;
        }

        public Criteria andPurchaseflgLessThanOrEqualTo(String value) {
            addCriterion("PurchaseFLG <=", value, "purchaseflg");
            return (Criteria) this;
        }

        public Criteria andPurchaseflgLike(String value) {
            addCriterion("PurchaseFLG like", value, "purchaseflg");
            return (Criteria) this;
        }

        public Criteria andPurchaseflgNotLike(String value) {
            addCriterion("PurchaseFLG not like", value, "purchaseflg");
            return (Criteria) this;
        }

        public Criteria andPurchaseflgIn(List<String> values) {
            addCriterion("PurchaseFLG in", values, "purchaseflg");
            return (Criteria) this;
        }

        public Criteria andPurchaseflgNotIn(List<String> values) {
            addCriterion("PurchaseFLG not in", values, "purchaseflg");
            return (Criteria) this;
        }

        public Criteria andPurchaseflgBetween(String value1, String value2) {
            addCriterion("PurchaseFLG between", value1, value2, "purchaseflg");
            return (Criteria) this;
        }

        public Criteria andPurchaseflgNotBetween(String value1, String value2) {
            addCriterion("PurchaseFLG not between", value1, value2, "purchaseflg");
            return (Criteria) this;
        }

        public Criteria andCustordflgIsNull() {
            addCriterion("CUSTORDFLG is null");
            return (Criteria) this;
        }

        public Criteria andCustordflgIsNotNull() {
            addCriterion("CUSTORDFLG is not null");
            return (Criteria) this;
        }

        public Criteria andCustordflgEqualTo(String value) {
            addCriterion("CUSTORDFLG =", value, "custordflg");
            return (Criteria) this;
        }

        public Criteria andCustordflgNotEqualTo(String value) {
            addCriterion("CUSTORDFLG <>", value, "custordflg");
            return (Criteria) this;
        }

        public Criteria andCustordflgGreaterThan(String value) {
            addCriterion("CUSTORDFLG >", value, "custordflg");
            return (Criteria) this;
        }

        public Criteria andCustordflgGreaterThanOrEqualTo(String value) {
            addCriterion("CUSTORDFLG >=", value, "custordflg");
            return (Criteria) this;
        }

        public Criteria andCustordflgLessThan(String value) {
            addCriterion("CUSTORDFLG <", value, "custordflg");
            return (Criteria) this;
        }

        public Criteria andCustordflgLessThanOrEqualTo(String value) {
            addCriterion("CUSTORDFLG <=", value, "custordflg");
            return (Criteria) this;
        }

        public Criteria andCustordflgLike(String value) {
            addCriterion("CUSTORDFLG like", value, "custordflg");
            return (Criteria) this;
        }

        public Criteria andCustordflgNotLike(String value) {
            addCriterion("CUSTORDFLG not like", value, "custordflg");
            return (Criteria) this;
        }

        public Criteria andCustordflgIn(List<String> values) {
            addCriterion("CUSTORDFLG in", values, "custordflg");
            return (Criteria) this;
        }

        public Criteria andCustordflgNotIn(List<String> values) {
            addCriterion("CUSTORDFLG not in", values, "custordflg");
            return (Criteria) this;
        }

        public Criteria andCustordflgBetween(String value1, String value2) {
            addCriterion("CUSTORDFLG between", value1, value2, "custordflg");
            return (Criteria) this;
        }

        public Criteria andCustordflgNotBetween(String value1, String value2) {
            addCriterion("CUSTORDFLG not between", value1, value2, "custordflg");
            return (Criteria) this;
        }

        public Criteria andProductioncdIsNull() {
            addCriterion("PRODUCTIONCD is null");
            return (Criteria) this;
        }

        public Criteria andProductioncdIsNotNull() {
            addCriterion("PRODUCTIONCD is not null");
            return (Criteria) this;
        }

        public Criteria andProductioncdEqualTo(String value) {
            addCriterion("PRODUCTIONCD =", value, "productioncd");
            return (Criteria) this;
        }

        public Criteria andProductioncdNotEqualTo(String value) {
            addCriterion("PRODUCTIONCD <>", value, "productioncd");
            return (Criteria) this;
        }

        public Criteria andProductioncdGreaterThan(String value) {
            addCriterion("PRODUCTIONCD >", value, "productioncd");
            return (Criteria) this;
        }

        public Criteria andProductioncdGreaterThanOrEqualTo(String value) {
            addCriterion("PRODUCTIONCD >=", value, "productioncd");
            return (Criteria) this;
        }

        public Criteria andProductioncdLessThan(String value) {
            addCriterion("PRODUCTIONCD <", value, "productioncd");
            return (Criteria) this;
        }

        public Criteria andProductioncdLessThanOrEqualTo(String value) {
            addCriterion("PRODUCTIONCD <=", value, "productioncd");
            return (Criteria) this;
        }

        public Criteria andProductioncdLike(String value) {
            addCriterion("PRODUCTIONCD like", value, "productioncd");
            return (Criteria) this;
        }

        public Criteria andProductioncdNotLike(String value) {
            addCriterion("PRODUCTIONCD not like", value, "productioncd");
            return (Criteria) this;
        }

        public Criteria andProductioncdIn(List<String> values) {
            addCriterion("PRODUCTIONCD in", values, "productioncd");
            return (Criteria) this;
        }

        public Criteria andProductioncdNotIn(List<String> values) {
            addCriterion("PRODUCTIONCD not in", values, "productioncd");
            return (Criteria) this;
        }

        public Criteria andProductioncdBetween(String value1, String value2) {
            addCriterion("PRODUCTIONCD between", value1, value2, "productioncd");
            return (Criteria) this;
        }

        public Criteria andProductioncdNotBetween(String value1, String value2) {
            addCriterion("PRODUCTIONCD not between", value1, value2, "productioncd");
            return (Criteria) this;
        }

        public Criteria andTransporttypeIsNull() {
            addCriterion("TransportType is null");
            return (Criteria) this;
        }

        public Criteria andTransporttypeIsNotNull() {
            addCriterion("TransportType is not null");
            return (Criteria) this;
        }

        public Criteria andTransporttypeEqualTo(String value) {
            addCriterion("TransportType =", value, "transporttype");
            return (Criteria) this;
        }

        public Criteria andTransporttypeNotEqualTo(String value) {
            addCriterion("TransportType <>", value, "transporttype");
            return (Criteria) this;
        }

        public Criteria andTransporttypeGreaterThan(String value) {
            addCriterion("TransportType >", value, "transporttype");
            return (Criteria) this;
        }

        public Criteria andTransporttypeGreaterThanOrEqualTo(String value) {
            addCriterion("TransportType >=", value, "transporttype");
            return (Criteria) this;
        }

        public Criteria andTransporttypeLessThan(String value) {
            addCriterion("TransportType <", value, "transporttype");
            return (Criteria) this;
        }

        public Criteria andTransporttypeLessThanOrEqualTo(String value) {
            addCriterion("TransportType <=", value, "transporttype");
            return (Criteria) this;
        }

        public Criteria andTransporttypeLike(String value) {
            addCriterion("TransportType like", value, "transporttype");
            return (Criteria) this;
        }

        public Criteria andTransporttypeNotLike(String value) {
            addCriterion("TransportType not like", value, "transporttype");
            return (Criteria) this;
        }

        public Criteria andTransporttypeIn(List<String> values) {
            addCriterion("TransportType in", values, "transporttype");
            return (Criteria) this;
        }

        public Criteria andTransporttypeNotIn(List<String> values) {
            addCriterion("TransportType not in", values, "transporttype");
            return (Criteria) this;
        }

        public Criteria andTransporttypeBetween(String value1, String value2) {
            addCriterion("TransportType between", value1, value2, "transporttype");
            return (Criteria) this;
        }

        public Criteria andTransporttypeNotBetween(String value1, String value2) {
            addCriterion("TransportType not between", value1, value2, "transporttype");
            return (Criteria) this;
        }

        public Criteria andTransportfeeIsNull() {
            addCriterion("TransportFee is null");
            return (Criteria) this;
        }

        public Criteria andTransportfeeIsNotNull() {
            addCriterion("TransportFee is not null");
            return (Criteria) this;
        }

        public Criteria andTransportfeeEqualTo(BigDecimal value) {
            addCriterion("TransportFee =", value, "transportfee");
            return (Criteria) this;
        }

        public Criteria andTransportfeeNotEqualTo(BigDecimal value) {
            addCriterion("TransportFee <>", value, "transportfee");
            return (Criteria) this;
        }

        public Criteria andTransportfeeGreaterThan(BigDecimal value) {
            addCriterion("TransportFee >", value, "transportfee");
            return (Criteria) this;
        }

        public Criteria andTransportfeeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("TransportFee >=", value, "transportfee");
            return (Criteria) this;
        }

        public Criteria andTransportfeeLessThan(BigDecimal value) {
            addCriterion("TransportFee <", value, "transportfee");
            return (Criteria) this;
        }

        public Criteria andTransportfeeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("TransportFee <=", value, "transportfee");
            return (Criteria) this;
        }

        public Criteria andTransportfeeIn(List<BigDecimal> values) {
            addCriterion("TransportFee in", values, "transportfee");
            return (Criteria) this;
        }

        public Criteria andTransportfeeNotIn(List<BigDecimal> values) {
            addCriterion("TransportFee not in", values, "transportfee");
            return (Criteria) this;
        }

        public Criteria andTransportfeeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TransportFee between", value1, value2, "transportfee");
            return (Criteria) this;
        }

        public Criteria andTransportfeeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TransportFee not between", value1, value2, "transportfee");
            return (Criteria) this;
        }

        public Criteria andTransportfeekbnIsNull() {
            addCriterion("TransportFeeKBN is null");
            return (Criteria) this;
        }

        public Criteria andTransportfeekbnIsNotNull() {
            addCriterion("TransportFeeKBN is not null");
            return (Criteria) this;
        }

        public Criteria andTransportfeekbnEqualTo(String value) {
            addCriterion("TransportFeeKBN =", value, "transportfeekbn");
            return (Criteria) this;
        }

        public Criteria andTransportfeekbnNotEqualTo(String value) {
            addCriterion("TransportFeeKBN <>", value, "transportfeekbn");
            return (Criteria) this;
        }

        public Criteria andTransportfeekbnGreaterThan(String value) {
            addCriterion("TransportFeeKBN >", value, "transportfeekbn");
            return (Criteria) this;
        }

        public Criteria andTransportfeekbnGreaterThanOrEqualTo(String value) {
            addCriterion("TransportFeeKBN >=", value, "transportfeekbn");
            return (Criteria) this;
        }

        public Criteria andTransportfeekbnLessThan(String value) {
            addCriterion("TransportFeeKBN <", value, "transportfeekbn");
            return (Criteria) this;
        }

        public Criteria andTransportfeekbnLessThanOrEqualTo(String value) {
            addCriterion("TransportFeeKBN <=", value, "transportfeekbn");
            return (Criteria) this;
        }

        public Criteria andTransportfeekbnLike(String value) {
            addCriterion("TransportFeeKBN like", value, "transportfeekbn");
            return (Criteria) this;
        }

        public Criteria andTransportfeekbnNotLike(String value) {
            addCriterion("TransportFeeKBN not like", value, "transportfeekbn");
            return (Criteria) this;
        }

        public Criteria andTransportfeekbnIn(List<String> values) {
            addCriterion("TransportFeeKBN in", values, "transportfeekbn");
            return (Criteria) this;
        }

        public Criteria andTransportfeekbnNotIn(List<String> values) {
            addCriterion("TransportFeeKBN not in", values, "transportfeekbn");
            return (Criteria) this;
        }

        public Criteria andTransportfeekbnBetween(String value1, String value2) {
            addCriterion("TransportFeeKBN between", value1, value2, "transportfeekbn");
            return (Criteria) this;
        }

        public Criteria andTransportfeekbnNotBetween(String value1, String value2) {
            addCriterion("TransportFeeKBN not between", value1, value2, "transportfeekbn");
            return (Criteria) this;
        }

        public Criteria andCurrencycdIsNull() {
            addCriterion("CurrencyCD is null");
            return (Criteria) this;
        }

        public Criteria andCurrencycdIsNotNull() {
            addCriterion("CurrencyCD is not null");
            return (Criteria) this;
        }

        public Criteria andCurrencycdEqualTo(String value) {
            addCriterion("CurrencyCD =", value, "currencycd");
            return (Criteria) this;
        }

        public Criteria andCurrencycdNotEqualTo(String value) {
            addCriterion("CurrencyCD <>", value, "currencycd");
            return (Criteria) this;
        }

        public Criteria andCurrencycdGreaterThan(String value) {
            addCriterion("CurrencyCD >", value, "currencycd");
            return (Criteria) this;
        }

        public Criteria andCurrencycdGreaterThanOrEqualTo(String value) {
            addCriterion("CurrencyCD >=", value, "currencycd");
            return (Criteria) this;
        }

        public Criteria andCurrencycdLessThan(String value) {
            addCriterion("CurrencyCD <", value, "currencycd");
            return (Criteria) this;
        }

        public Criteria andCurrencycdLessThanOrEqualTo(String value) {
            addCriterion("CurrencyCD <=", value, "currencycd");
            return (Criteria) this;
        }

        public Criteria andCurrencycdLike(String value) {
            addCriterion("CurrencyCD like", value, "currencycd");
            return (Criteria) this;
        }

        public Criteria andCurrencycdNotLike(String value) {
            addCriterion("CurrencyCD not like", value, "currencycd");
            return (Criteria) this;
        }

        public Criteria andCurrencycdIn(List<String> values) {
            addCriterion("CurrencyCD in", values, "currencycd");
            return (Criteria) this;
        }

        public Criteria andCurrencycdNotIn(List<String> values) {
            addCriterion("CurrencyCD not in", values, "currencycd");
            return (Criteria) this;
        }

        public Criteria andCurrencycdBetween(String value1, String value2) {
            addCriterion("CurrencyCD between", value1, value2, "currencycd");
            return (Criteria) this;
        }

        public Criteria andCurrencycdNotBetween(String value1, String value2) {
            addCriterion("CurrencyCD not between", value1, value2, "currencycd");
            return (Criteria) this;
        }

        public Criteria andOrderstatusIsNull() {
            addCriterion("OrderStatus is null");
            return (Criteria) this;
        }

        public Criteria andOrderstatusIsNotNull() {
            addCriterion("OrderStatus is not null");
            return (Criteria) this;
        }

        public Criteria andOrderstatusEqualTo(String value) {
            addCriterion("OrderStatus =", value, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andOrderstatusNotEqualTo(String value) {
            addCriterion("OrderStatus <>", value, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andOrderstatusGreaterThan(String value) {
            addCriterion("OrderStatus >", value, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andOrderstatusGreaterThanOrEqualTo(String value) {
            addCriterion("OrderStatus >=", value, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andOrderstatusLessThan(String value) {
            addCriterion("OrderStatus <", value, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andOrderstatusLessThanOrEqualTo(String value) {
            addCriterion("OrderStatus <=", value, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andOrderstatusLike(String value) {
            addCriterion("OrderStatus like", value, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andOrderstatusNotLike(String value) {
            addCriterion("OrderStatus not like", value, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andOrderstatusIn(List<String> values) {
            addCriterion("OrderStatus in", values, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andOrderstatusNotIn(List<String> values) {
            addCriterion("OrderStatus not in", values, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andOrderstatusBetween(String value1, String value2) {
            addCriterion("OrderStatus between", value1, value2, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andOrderstatusNotBetween(String value1, String value2) {
            addCriterion("OrderStatus not between", value1, value2, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andPlaninstcymdIsNull() {
            addCriterion("PlanInstcYMD is null");
            return (Criteria) this;
        }

        public Criteria andPlaninstcymdIsNotNull() {
            addCriterion("PlanInstcYMD is not null");
            return (Criteria) this;
        }

        public Criteria andPlaninstcymdEqualTo(String value) {
            addCriterion("PlanInstcYMD =", value, "planinstcymd");
            return (Criteria) this;
        }

        public Criteria andPlaninstcymdNotEqualTo(String value) {
            addCriterion("PlanInstcYMD <>", value, "planinstcymd");
            return (Criteria) this;
        }

        public Criteria andPlaninstcymdGreaterThan(String value) {
            addCriterion("PlanInstcYMD >", value, "planinstcymd");
            return (Criteria) this;
        }

        public Criteria andPlaninstcymdGreaterThanOrEqualTo(String value) {
            addCriterion("PlanInstcYMD >=", value, "planinstcymd");
            return (Criteria) this;
        }

        public Criteria andPlaninstcymdLessThan(String value) {
            addCriterion("PlanInstcYMD <", value, "planinstcymd");
            return (Criteria) this;
        }

        public Criteria andPlaninstcymdLessThanOrEqualTo(String value) {
            addCriterion("PlanInstcYMD <=", value, "planinstcymd");
            return (Criteria) this;
        }

        public Criteria andPlaninstcymdLike(String value) {
            addCriterion("PlanInstcYMD like", value, "planinstcymd");
            return (Criteria) this;
        }

        public Criteria andPlaninstcymdNotLike(String value) {
            addCriterion("PlanInstcYMD not like", value, "planinstcymd");
            return (Criteria) this;
        }

        public Criteria andPlaninstcymdIn(List<String> values) {
            addCriterion("PlanInstcYMD in", values, "planinstcymd");
            return (Criteria) this;
        }

        public Criteria andPlaninstcymdNotIn(List<String> values) {
            addCriterion("PlanInstcYMD not in", values, "planinstcymd");
            return (Criteria) this;
        }

        public Criteria andPlaninstcymdBetween(String value1, String value2) {
            addCriterion("PlanInstcYMD between", value1, value2, "planinstcymd");
            return (Criteria) this;
        }

        public Criteria andPlaninstcymdNotBetween(String value1, String value2) {
            addCriterion("PlanInstcYMD not between", value1, value2, "planinstcymd");
            return (Criteria) this;
        }

        public Criteria andCustconfirmymdIsNull() {
            addCriterion("CustConfirmYMD is null");
            return (Criteria) this;
        }

        public Criteria andCustconfirmymdIsNotNull() {
            addCriterion("CustConfirmYMD is not null");
            return (Criteria) this;
        }

        public Criteria andCustconfirmymdEqualTo(String value) {
            addCriterion("CustConfirmYMD =", value, "custconfirmymd");
            return (Criteria) this;
        }

        public Criteria andCustconfirmymdNotEqualTo(String value) {
            addCriterion("CustConfirmYMD <>", value, "custconfirmymd");
            return (Criteria) this;
        }

        public Criteria andCustconfirmymdGreaterThan(String value) {
            addCriterion("CustConfirmYMD >", value, "custconfirmymd");
            return (Criteria) this;
        }

        public Criteria andCustconfirmymdGreaterThanOrEqualTo(String value) {
            addCriterion("CustConfirmYMD >=", value, "custconfirmymd");
            return (Criteria) this;
        }

        public Criteria andCustconfirmymdLessThan(String value) {
            addCriterion("CustConfirmYMD <", value, "custconfirmymd");
            return (Criteria) this;
        }

        public Criteria andCustconfirmymdLessThanOrEqualTo(String value) {
            addCriterion("CustConfirmYMD <=", value, "custconfirmymd");
            return (Criteria) this;
        }

        public Criteria andCustconfirmymdLike(String value) {
            addCriterion("CustConfirmYMD like", value, "custconfirmymd");
            return (Criteria) this;
        }

        public Criteria andCustconfirmymdNotLike(String value) {
            addCriterion("CustConfirmYMD not like", value, "custconfirmymd");
            return (Criteria) this;
        }

        public Criteria andCustconfirmymdIn(List<String> values) {
            addCriterion("CustConfirmYMD in", values, "custconfirmymd");
            return (Criteria) this;
        }

        public Criteria andCustconfirmymdNotIn(List<String> values) {
            addCriterion("CustConfirmYMD not in", values, "custconfirmymd");
            return (Criteria) this;
        }

        public Criteria andCustconfirmymdBetween(String value1, String value2) {
            addCriterion("CustConfirmYMD between", value1, value2, "custconfirmymd");
            return (Criteria) this;
        }

        public Criteria andCustconfirmymdNotBetween(String value1, String value2) {
            addCriterion("CustConfirmYMD not between", value1, value2, "custconfirmymd");
            return (Criteria) this;
        }

        public Criteria andPurchaseymdIsNull() {
            addCriterion("PurchaseYMD is null");
            return (Criteria) this;
        }

        public Criteria andPurchaseymdIsNotNull() {
            addCriterion("PurchaseYMD is not null");
            return (Criteria) this;
        }

        public Criteria andPurchaseymdEqualTo(String value) {
            addCriterion("PurchaseYMD =", value, "purchaseymd");
            return (Criteria) this;
        }

        public Criteria andPurchaseymdNotEqualTo(String value) {
            addCriterion("PurchaseYMD <>", value, "purchaseymd");
            return (Criteria) this;
        }

        public Criteria andPurchaseymdGreaterThan(String value) {
            addCriterion("PurchaseYMD >", value, "purchaseymd");
            return (Criteria) this;
        }

        public Criteria andPurchaseymdGreaterThanOrEqualTo(String value) {
            addCriterion("PurchaseYMD >=", value, "purchaseymd");
            return (Criteria) this;
        }

        public Criteria andPurchaseymdLessThan(String value) {
            addCriterion("PurchaseYMD <", value, "purchaseymd");
            return (Criteria) this;
        }

        public Criteria andPurchaseymdLessThanOrEqualTo(String value) {
            addCriterion("PurchaseYMD <=", value, "purchaseymd");
            return (Criteria) this;
        }

        public Criteria andPurchaseymdLike(String value) {
            addCriterion("PurchaseYMD like", value, "purchaseymd");
            return (Criteria) this;
        }

        public Criteria andPurchaseymdNotLike(String value) {
            addCriterion("PurchaseYMD not like", value, "purchaseymd");
            return (Criteria) this;
        }

        public Criteria andPurchaseymdIn(List<String> values) {
            addCriterion("PurchaseYMD in", values, "purchaseymd");
            return (Criteria) this;
        }

        public Criteria andPurchaseymdNotIn(List<String> values) {
            addCriterion("PurchaseYMD not in", values, "purchaseymd");
            return (Criteria) this;
        }

        public Criteria andPurchaseymdBetween(String value1, String value2) {
            addCriterion("PurchaseYMD between", value1, value2, "purchaseymd");
            return (Criteria) this;
        }

        public Criteria andPurchaseymdNotBetween(String value1, String value2) {
            addCriterion("PurchaseYMD not between", value1, value2, "purchaseymd");
            return (Criteria) this;
        }

        public Criteria andInstockymdIsNull() {
            addCriterion("InstockYMD is null");
            return (Criteria) this;
        }

        public Criteria andInstockymdIsNotNull() {
            addCriterion("InstockYMD is not null");
            return (Criteria) this;
        }

        public Criteria andInstockymdEqualTo(String value) {
            addCriterion("InstockYMD =", value, "instockymd");
            return (Criteria) this;
        }

        public Criteria andInstockymdNotEqualTo(String value) {
            addCriterion("InstockYMD <>", value, "instockymd");
            return (Criteria) this;
        }

        public Criteria andInstockymdGreaterThan(String value) {
            addCriterion("InstockYMD >", value, "instockymd");
            return (Criteria) this;
        }

        public Criteria andInstockymdGreaterThanOrEqualTo(String value) {
            addCriterion("InstockYMD >=", value, "instockymd");
            return (Criteria) this;
        }

        public Criteria andInstockymdLessThan(String value) {
            addCriterion("InstockYMD <", value, "instockymd");
            return (Criteria) this;
        }

        public Criteria andInstockymdLessThanOrEqualTo(String value) {
            addCriterion("InstockYMD <=", value, "instockymd");
            return (Criteria) this;
        }

        public Criteria andInstockymdLike(String value) {
            addCriterion("InstockYMD like", value, "instockymd");
            return (Criteria) this;
        }

        public Criteria andInstockymdNotLike(String value) {
            addCriterion("InstockYMD not like", value, "instockymd");
            return (Criteria) this;
        }

        public Criteria andInstockymdIn(List<String> values) {
            addCriterion("InstockYMD in", values, "instockymd");
            return (Criteria) this;
        }

        public Criteria andInstockymdNotIn(List<String> values) {
            addCriterion("InstockYMD not in", values, "instockymd");
            return (Criteria) this;
        }

        public Criteria andInstockymdBetween(String value1, String value2) {
            addCriterion("InstockYMD between", value1, value2, "instockymd");
            return (Criteria) this;
        }

        public Criteria andInstockymdNotBetween(String value1, String value2) {
            addCriterion("InstockYMD not between", value1, value2, "instockymd");
            return (Criteria) this;
        }

        public Criteria andPurchasemanIsNull() {
            addCriterion("PurchaseMan is null");
            return (Criteria) this;
        }

        public Criteria andPurchasemanIsNotNull() {
            addCriterion("PurchaseMan is not null");
            return (Criteria) this;
        }

        public Criteria andPurchasemanEqualTo(String value) {
            addCriterion("PurchaseMan =", value, "purchaseman");
            return (Criteria) this;
        }

        public Criteria andPurchasemanNotEqualTo(String value) {
            addCriterion("PurchaseMan <>", value, "purchaseman");
            return (Criteria) this;
        }

        public Criteria andPurchasemanGreaterThan(String value) {
            addCriterion("PurchaseMan >", value, "purchaseman");
            return (Criteria) this;
        }

        public Criteria andPurchasemanGreaterThanOrEqualTo(String value) {
            addCriterion("PurchaseMan >=", value, "purchaseman");
            return (Criteria) this;
        }

        public Criteria andPurchasemanLessThan(String value) {
            addCriterion("PurchaseMan <", value, "purchaseman");
            return (Criteria) this;
        }

        public Criteria andPurchasemanLessThanOrEqualTo(String value) {
            addCriterion("PurchaseMan <=", value, "purchaseman");
            return (Criteria) this;
        }

        public Criteria andPurchasemanLike(String value) {
            addCriterion("PurchaseMan like", value, "purchaseman");
            return (Criteria) this;
        }

        public Criteria andPurchasemanNotLike(String value) {
            addCriterion("PurchaseMan not like", value, "purchaseman");
            return (Criteria) this;
        }

        public Criteria andPurchasemanIn(List<String> values) {
            addCriterion("PurchaseMan in", values, "purchaseman");
            return (Criteria) this;
        }

        public Criteria andPurchasemanNotIn(List<String> values) {
            addCriterion("PurchaseMan not in", values, "purchaseman");
            return (Criteria) this;
        }

        public Criteria andPurchasemanBetween(String value1, String value2) {
            addCriterion("PurchaseMan between", value1, value2, "purchaseman");
            return (Criteria) this;
        }

        public Criteria andPurchasemanNotBetween(String value1, String value2) {
            addCriterion("PurchaseMan not between", value1, value2, "purchaseman");
            return (Criteria) this;
        }

        public Criteria andInstockmanIsNull() {
            addCriterion("InstockMan is null");
            return (Criteria) this;
        }

        public Criteria andInstockmanIsNotNull() {
            addCriterion("InstockMan is not null");
            return (Criteria) this;
        }

        public Criteria andInstockmanEqualTo(String value) {
            addCriterion("InstockMan =", value, "instockman");
            return (Criteria) this;
        }

        public Criteria andInstockmanNotEqualTo(String value) {
            addCriterion("InstockMan <>", value, "instockman");
            return (Criteria) this;
        }

        public Criteria andInstockmanGreaterThan(String value) {
            addCriterion("InstockMan >", value, "instockman");
            return (Criteria) this;
        }

        public Criteria andInstockmanGreaterThanOrEqualTo(String value) {
            addCriterion("InstockMan >=", value, "instockman");
            return (Criteria) this;
        }

        public Criteria andInstockmanLessThan(String value) {
            addCriterion("InstockMan <", value, "instockman");
            return (Criteria) this;
        }

        public Criteria andInstockmanLessThanOrEqualTo(String value) {
            addCriterion("InstockMan <=", value, "instockman");
            return (Criteria) this;
        }

        public Criteria andInstockmanLike(String value) {
            addCriterion("InstockMan like", value, "instockman");
            return (Criteria) this;
        }

        public Criteria andInstockmanNotLike(String value) {
            addCriterion("InstockMan not like", value, "instockman");
            return (Criteria) this;
        }

        public Criteria andInstockmanIn(List<String> values) {
            addCriterion("InstockMan in", values, "instockman");
            return (Criteria) this;
        }

        public Criteria andInstockmanNotIn(List<String> values) {
            addCriterion("InstockMan not in", values, "instockman");
            return (Criteria) this;
        }

        public Criteria andInstockmanBetween(String value1, String value2) {
            addCriterion("InstockMan between", value1, value2, "instockman");
            return (Criteria) this;
        }

        public Criteria andInstockmanNotBetween(String value1, String value2) {
            addCriterion("InstockMan not between", value1, value2, "instockman");
            return (Criteria) this;
        }

        public Criteria andActionflgIsNull() {
            addCriterion("ActionFLG is null");
            return (Criteria) this;
        }

        public Criteria andActionflgIsNotNull() {
            addCriterion("ActionFLG is not null");
            return (Criteria) this;
        }

        public Criteria andActionflgEqualTo(String value) {
            addCriterion("ActionFLG =", value, "actionflg");
            return (Criteria) this;
        }

        public Criteria andActionflgNotEqualTo(String value) {
            addCriterion("ActionFLG <>", value, "actionflg");
            return (Criteria) this;
        }

        public Criteria andActionflgGreaterThan(String value) {
            addCriterion("ActionFLG >", value, "actionflg");
            return (Criteria) this;
        }

        public Criteria andActionflgGreaterThanOrEqualTo(String value) {
            addCriterion("ActionFLG >=", value, "actionflg");
            return (Criteria) this;
        }

        public Criteria andActionflgLessThan(String value) {
            addCriterion("ActionFLG <", value, "actionflg");
            return (Criteria) this;
        }

        public Criteria andActionflgLessThanOrEqualTo(String value) {
            addCriterion("ActionFLG <=", value, "actionflg");
            return (Criteria) this;
        }

        public Criteria andActionflgLike(String value) {
            addCriterion("ActionFLG like", value, "actionflg");
            return (Criteria) this;
        }

        public Criteria andActionflgNotLike(String value) {
            addCriterion("ActionFLG not like", value, "actionflg");
            return (Criteria) this;
        }

        public Criteria andActionflgIn(List<String> values) {
            addCriterion("ActionFLG in", values, "actionflg");
            return (Criteria) this;
        }

        public Criteria andActionflgNotIn(List<String> values) {
            addCriterion("ActionFLG not in", values, "actionflg");
            return (Criteria) this;
        }

        public Criteria andActionflgBetween(String value1, String value2) {
            addCriterion("ActionFLG between", value1, value2, "actionflg");
            return (Criteria) this;
        }

        public Criteria andActionflgNotBetween(String value1, String value2) {
            addCriterion("ActionFLG not between", value1, value2, "actionflg");
            return (Criteria) this;
        }

        public Criteria andPrintflgIsNull() {
            addCriterion("PrintFLG is null");
            return (Criteria) this;
        }

        public Criteria andPrintflgIsNotNull() {
            addCriterion("PrintFLG is not null");
            return (Criteria) this;
        }

        public Criteria andPrintflgEqualTo(String value) {
            addCriterion("PrintFLG =", value, "printflg");
            return (Criteria) this;
        }

        public Criteria andPrintflgNotEqualTo(String value) {
            addCriterion("PrintFLG <>", value, "printflg");
            return (Criteria) this;
        }

        public Criteria andPrintflgGreaterThan(String value) {
            addCriterion("PrintFLG >", value, "printflg");
            return (Criteria) this;
        }

        public Criteria andPrintflgGreaterThanOrEqualTo(String value) {
            addCriterion("PrintFLG >=", value, "printflg");
            return (Criteria) this;
        }

        public Criteria andPrintflgLessThan(String value) {
            addCriterion("PrintFLG <", value, "printflg");
            return (Criteria) this;
        }

        public Criteria andPrintflgLessThanOrEqualTo(String value) {
            addCriterion("PrintFLG <=", value, "printflg");
            return (Criteria) this;
        }

        public Criteria andPrintflgLike(String value) {
            addCriterion("PrintFLG like", value, "printflg");
            return (Criteria) this;
        }

        public Criteria andPrintflgNotLike(String value) {
            addCriterion("PrintFLG not like", value, "printflg");
            return (Criteria) this;
        }

        public Criteria andPrintflgIn(List<String> values) {
            addCriterion("PrintFLG in", values, "printflg");
            return (Criteria) this;
        }

        public Criteria andPrintflgNotIn(List<String> values) {
            addCriterion("PrintFLG not in", values, "printflg");
            return (Criteria) this;
        }

        public Criteria andPrintflgBetween(String value1, String value2) {
            addCriterion("PrintFLG between", value1, value2, "printflg");
            return (Criteria) this;
        }

        public Criteria andPrintflgNotBetween(String value1, String value2) {
            addCriterion("PrintFLG not between", value1, value2, "printflg");
            return (Criteria) this;
        }

        public Criteria andPrintymdIsNull() {
            addCriterion("PrintYMD is null");
            return (Criteria) this;
        }

        public Criteria andPrintymdIsNotNull() {
            addCriterion("PrintYMD is not null");
            return (Criteria) this;
        }

        public Criteria andPrintymdEqualTo(String value) {
            addCriterion("PrintYMD =", value, "printymd");
            return (Criteria) this;
        }

        public Criteria andPrintymdNotEqualTo(String value) {
            addCriterion("PrintYMD <>", value, "printymd");
            return (Criteria) this;
        }

        public Criteria andPrintymdGreaterThan(String value) {
            addCriterion("PrintYMD >", value, "printymd");
            return (Criteria) this;
        }

        public Criteria andPrintymdGreaterThanOrEqualTo(String value) {
            addCriterion("PrintYMD >=", value, "printymd");
            return (Criteria) this;
        }

        public Criteria andPrintymdLessThan(String value) {
            addCriterion("PrintYMD <", value, "printymd");
            return (Criteria) this;
        }

        public Criteria andPrintymdLessThanOrEqualTo(String value) {
            addCriterion("PrintYMD <=", value, "printymd");
            return (Criteria) this;
        }

        public Criteria andPrintymdLike(String value) {
            addCriterion("PrintYMD like", value, "printymd");
            return (Criteria) this;
        }

        public Criteria andPrintymdNotLike(String value) {
            addCriterion("PrintYMD not like", value, "printymd");
            return (Criteria) this;
        }

        public Criteria andPrintymdIn(List<String> values) {
            addCriterion("PrintYMD in", values, "printymd");
            return (Criteria) this;
        }

        public Criteria andPrintymdNotIn(List<String> values) {
            addCriterion("PrintYMD not in", values, "printymd");
            return (Criteria) this;
        }

        public Criteria andPrintymdBetween(String value1, String value2) {
            addCriterion("PrintYMD between", value1, value2, "printymd");
            return (Criteria) this;
        }

        public Criteria andPrintymdNotBetween(String value1, String value2) {
            addCriterion("PrintYMD not between", value1, value2, "printymd");
            return (Criteria) this;
        }

        public Criteria andPrintmanIsNull() {
            addCriterion("PrintMan is null");
            return (Criteria) this;
        }

        public Criteria andPrintmanIsNotNull() {
            addCriterion("PrintMan is not null");
            return (Criteria) this;
        }

        public Criteria andPrintmanEqualTo(String value) {
            addCriterion("PrintMan =", value, "printman");
            return (Criteria) this;
        }

        public Criteria andPrintmanNotEqualTo(String value) {
            addCriterion("PrintMan <>", value, "printman");
            return (Criteria) this;
        }

        public Criteria andPrintmanGreaterThan(String value) {
            addCriterion("PrintMan >", value, "printman");
            return (Criteria) this;
        }

        public Criteria andPrintmanGreaterThanOrEqualTo(String value) {
            addCriterion("PrintMan >=", value, "printman");
            return (Criteria) this;
        }

        public Criteria andPrintmanLessThan(String value) {
            addCriterion("PrintMan <", value, "printman");
            return (Criteria) this;
        }

        public Criteria andPrintmanLessThanOrEqualTo(String value) {
            addCriterion("PrintMan <=", value, "printman");
            return (Criteria) this;
        }

        public Criteria andPrintmanLike(String value) {
            addCriterion("PrintMan like", value, "printman");
            return (Criteria) this;
        }

        public Criteria andPrintmanNotLike(String value) {
            addCriterion("PrintMan not like", value, "printman");
            return (Criteria) this;
        }

        public Criteria andPrintmanIn(List<String> values) {
            addCriterion("PrintMan in", values, "printman");
            return (Criteria) this;
        }

        public Criteria andPrintmanNotIn(List<String> values) {
            addCriterion("PrintMan not in", values, "printman");
            return (Criteria) this;
        }

        public Criteria andPrintmanBetween(String value1, String value2) {
            addCriterion("PrintMan between", value1, value2, "printman");
            return (Criteria) this;
        }

        public Criteria andPrintmanNotBetween(String value1, String value2) {
            addCriterion("PrintMan not between", value1, value2, "printman");
            return (Criteria) this;
        }

        public Criteria andMemoIsNull() {
            addCriterion("Memo is null");
            return (Criteria) this;
        }

        public Criteria andMemoIsNotNull() {
            addCriterion("Memo is not null");
            return (Criteria) this;
        }

        public Criteria andMemoEqualTo(String value) {
            addCriterion("Memo =", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoNotEqualTo(String value) {
            addCriterion("Memo <>", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoGreaterThan(String value) {
            addCriterion("Memo >", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoGreaterThanOrEqualTo(String value) {
            addCriterion("Memo >=", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoLessThan(String value) {
            addCriterion("Memo <", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoLessThanOrEqualTo(String value) {
            addCriterion("Memo <=", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoLike(String value) {
            addCriterion("Memo like", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoNotLike(String value) {
            addCriterion("Memo not like", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoIn(List<String> values) {
            addCriterion("Memo in", values, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoNotIn(List<String> values) {
            addCriterion("Memo not in", values, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoBetween(String value1, String value2) {
            addCriterion("Memo between", value1, value2, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoNotBetween(String value1, String value2) {
            addCriterion("Memo not between", value1, value2, "memo");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIsNull() {
            addCriterion("UpdateTime is null");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIsNotNull() {
            addCriterion("UpdateTime is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeEqualTo(Date value) {
            addCriterionForJDBCDate("UpdateTime =", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotEqualTo(Date value) {
            addCriterionForJDBCDate("UpdateTime <>", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeGreaterThan(Date value) {
            addCriterionForJDBCDate("UpdateTime >", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("UpdateTime >=", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeLessThan(Date value) {
            addCriterionForJDBCDate("UpdateTime <", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("UpdateTime <=", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIn(List<Date> values) {
            addCriterionForJDBCDate("UpdateTime in", values, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotIn(List<Date> values) {
            addCriterionForJDBCDate("UpdateTime not in", values, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("UpdateTime between", value1, value2, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("UpdateTime not between", value1, value2, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatemanIsNull() {
            addCriterion("UpdateMan is null");
            return (Criteria) this;
        }

        public Criteria andUpdatemanIsNotNull() {
            addCriterion("UpdateMan is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatemanEqualTo(String value) {
            addCriterion("UpdateMan =", value, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanNotEqualTo(String value) {
            addCriterion("UpdateMan <>", value, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanGreaterThan(String value) {
            addCriterion("UpdateMan >", value, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanGreaterThanOrEqualTo(String value) {
            addCriterion("UpdateMan >=", value, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanLessThan(String value) {
            addCriterion("UpdateMan <", value, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanLessThanOrEqualTo(String value) {
            addCriterion("UpdateMan <=", value, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanLike(String value) {
            addCriterion("UpdateMan like", value, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanNotLike(String value) {
            addCriterion("UpdateMan not like", value, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanIn(List<String> values) {
            addCriterion("UpdateMan in", values, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanNotIn(List<String> values) {
            addCriterion("UpdateMan not in", values, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanBetween(String value1, String value2) {
            addCriterion("UpdateMan between", value1, value2, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanNotBetween(String value1, String value2) {
            addCriterion("UpdateMan not between", value1, value2, "updateman");
            return (Criteria) this;
        }

        public Criteria andSubsellflgIsNull() {
            addCriterion("SubSellFlg is null");
            return (Criteria) this;
        }

        public Criteria andSubsellflgIsNotNull() {
            addCriterion("SubSellFlg is not null");
            return (Criteria) this;
        }

        public Criteria andSubsellflgEqualTo(String value) {
            addCriterion("SubSellFlg =", value, "subsellflg");
            return (Criteria) this;
        }

        public Criteria andSubsellflgNotEqualTo(String value) {
            addCriterion("SubSellFlg <>", value, "subsellflg");
            return (Criteria) this;
        }

        public Criteria andSubsellflgGreaterThan(String value) {
            addCriterion("SubSellFlg >", value, "subsellflg");
            return (Criteria) this;
        }

        public Criteria andSubsellflgGreaterThanOrEqualTo(String value) {
            addCriterion("SubSellFlg >=", value, "subsellflg");
            return (Criteria) this;
        }

        public Criteria andSubsellflgLessThan(String value) {
            addCriterion("SubSellFlg <", value, "subsellflg");
            return (Criteria) this;
        }

        public Criteria andSubsellflgLessThanOrEqualTo(String value) {
            addCriterion("SubSellFlg <=", value, "subsellflg");
            return (Criteria) this;
        }

        public Criteria andSubsellflgLike(String value) {
            addCriterion("SubSellFlg like", value, "subsellflg");
            return (Criteria) this;
        }

        public Criteria andSubsellflgNotLike(String value) {
            addCriterion("SubSellFlg not like", value, "subsellflg");
            return (Criteria) this;
        }

        public Criteria andSubsellflgIn(List<String> values) {
            addCriterion("SubSellFlg in", values, "subsellflg");
            return (Criteria) this;
        }

        public Criteria andSubsellflgNotIn(List<String> values) {
            addCriterion("SubSellFlg not in", values, "subsellflg");
            return (Criteria) this;
        }

        public Criteria andSubsellflgBetween(String value1, String value2) {
            addCriterion("SubSellFlg between", value1, value2, "subsellflg");
            return (Criteria) this;
        }

        public Criteria andSubsellflgNotBetween(String value1, String value2) {
            addCriterion("SubSellFlg not between", value1, value2, "subsellflg");
            return (Criteria) this;
        }
    }

    /**
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}